Open an object in datasheet view
To open a table, form, or query in Datasheet view:
1) Choose the appropriate tab in the Database window.
NOTE: There are 6 object tabs: 'Tables', 'Forms', 'Queries', Reports', 'Macros', and 'Modules'.
2) Select the desired object from the list box in the Database window.
3) Choose the 'Open' button in the Database window. (The selected table, form, or query opens in Datasheet view.)